//
//  NationalBondsJa.h
//  MarketDataColloctor
//
//  Created by jiro on 10/03/27.
//  Copyright 2010 jiro music. All rights reserved.
//

#import <Cocoa/Cocoa.h>
#import "DbCodeTableEntry.h"

class NationalBondsJaType 
{
public:
	enum Type
	{
		Year1,
		Years2,
		Years3,
		Years4,
		Years5,
		Years6,
		Years7,
		Years8,
		Years9,
		Years10,
		Years15,
		Years20,
		Years25,
		Years30,
		Years40,
	};
	
	static NSString* ToString( Type type )
	{
		switch ( type )
		{
		case Year1:		return @"1 year";
		case Years2:	return @"2 year";
		case Years3:	return @"3 year";
		case Years4:	return @"4 year";
		case Years5:	return @"5 year";
		case Years6:	return @"6 year";
		case Years7:	return @"7 year";
		case Years8:	return @"8 year";
		case Years9:	return @"9 year";
		case Years10:	return @"10 year";
		case Years15:	return @"15 year";
		case Years20:	return @"20 year";
		case Years25:	return @"25 year";
		case Years30:	return @"30 year";
		case Years40:	return @"40 year";
		default: return @"";
		}
	}
};


@interface NationalBondsJa : DbCodeTableEntry {
}

+ (NationalBondsJa*) nationalBondsJaWithValues: (NSArray*) values;

+ (NSString*) tableName;

+ (NSString*) queryCreateTable;

+ (NSString*) queryInsertInitialValues;

- (NSString*) tableName;

- (NSString*) queryInsertValue;

- (NSString*) sqlInsertStatement;

//	---- sql query  ---- //
+ (NSString*) querySelectAll;

- (NSString*) queryInsert;
- (NSString*) queryInsertValue;

@end
